Filter Options for Advanced Mode
Advanced mode provides additional filter options. You can:
- Define additional filter rules using any of four connectors:
- Specify the order in which to apply a filter set: Select the Up and Down arrows.
- Make a prompt required: Select Required from the Prompt list.
- Select Required to require a user to enter a value when prompted at runtime. If the user does not enter one, the query returns no results.
- Select Optional to make the value optional. If the user does not enter a value, filtering does not occur and the query returns all values. A special -All- value appears in an optional filter field after the first run of a query, which has the same effect as leaving the filter field blank.
- A Multiple checkbox is visible when the filter Property contains a discrete drop-down list of values. Selecting this checkbox changes the Value selector from a simple drop-down list that enables you to select only one specific value to a multi-select control that enables you to select multiple values. The selected values are used as an OR comparison. See Defining multiple values for a filter property for more information.
Note: Even if the Multiple checkbox is not visible, you can still manually specify multiple values for any filter property by entering a comma-delimited list of quoted values. For example, you could specify the following multiple values for a City property: "Austin","Houston","Dallas".
- A Limit the number of results returned checkbox in the Query Options section enables you to specify a limit to the number of rows that can be returned by the query. By setting the corresponding Prompt to No, you make the specified value a hard limit for the query. By setting the Prompt to Optional or Required, you make the specified value a default that can be overridden by users when they run the query. When coupled with sort criteria, this filter can effect a "top n records" type of result. See Limiting the rows returned by a query for more information.